﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsManutOrcamento" targetNamespace="http://tempuri.org/dsManutOrcamento.xsd" xmlns:mstns="http://tempuri.org/dsManutOrcamento.xsd" xmlns="http://tempuri.org/dsManutOrcamento.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="SamecaGestConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SamecaGestConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SamecaGestV2.My.MySettings.GlobalReference.Default.SamecaGestConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblCustomerTableAdapter" GeneratorDataComponentClassName="tblCustomerTableAdapter" Name="tblCustomer" UserDataComponentName="tblCustomerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SamecaGestConnectionString (MySettings)" DbObjectName="SAMECAGEST.dbo.tblCustomer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        No_, Name
FROM            tblCustomer
WHERE        ([Salesperson Code] like @vendedor) AND (Company = @company)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="vendedor" ColumnName="Salesperson Code" DataSourceName="SAMECAGEST.dbo.tblCustomer" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@vendedor" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="Salesperson Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="company" ColumnName="Company" DataSourceName="SAMECAGEST.dbo.tblCustomer" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@company" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="No_" DataSetColumn="No_" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SamecaGestConnectionString (MySettings)" DbObjectName="SAMECAGEST.dbo.tblCustomer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT tblCustomer.Name, tblCustomer.No_ FROM tblCustomer INNER JOIN tblDefaultDimension ON tblCustomer.No_ = tblDefaultDimension.No_ AND tblCustomer.Company = tblDefaultDimension.Company WHERE (tblCustomer.Company = @company) AND (tblDefaultDimension.[Table ID] = 18) AND (tblDefaultDimension.[Dimension Code] = 'UNEGOCIO') AND (tblDefaultDimension.[Dimension Value Code] LIKE @UN)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="company" ColumnName="Company" DataSourceName="SAMECAGEST.dbo.tblCustomer" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@company" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="UN" ColumnName="Dimension Value Code" DataSourceName="SAMECAGEST.dbo.tblDefaultDimension" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@UN" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Dimension Value Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblItemTableAdapter" GeneratorDataComponentClassName="tblItemTableAdapter" Name="tblItem" UserDataComponentName="tblItemTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SamecaGestConnectionString (MySettings)" DbObjectName="SamecaGest.dbo.tblItem" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        No_, [Extended Description]
FROM            tblItem
WHERE        (Company = @company)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="company" ColumnName="Company" DataSourceName="SamecaGest.dbo.tblItem" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@company" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="No_" DataSetColumn="No_" />
              <Mapping SourceColumn="Extended Description" DataSetColumn="Extended Description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrcamentoVendedorTableAdapter" GeneratorDataComponentClassName="OrcamentoVendedorTableAdapter" Name="OrcamentoVendedor" UserDataComponentName="OrcamentoVendedorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SamecaGestConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblOrcamento.CODCLI, tblCustomer.Name AS DESCCLI, tblOrcamento.CODPROD, tblItem.[Extended Description] AS DESCITEM, tblOrcamento.Armazem, 
                         tblDefaultDimension.[Dimension Value Code] AS UN, tblOrcamento.[QD-1], tblOrcamento.[VD-1], tblOrcamento.[CT-1], tblOrcamento.[PMV-1], 
                         tblOrcamento.[MRG-1], tblOrcamento.[%-1], tblOrcamento.QD, tblOrcamento.VD, tblOrcamento.CT, tblOrcamento.PMV, tblOrcamento.MRG, tblOrcamento.[%], 
                         tblOrcamento.ULTPV, tblOrcamento.ULTPC, tblOrcamento.[QD-ORC], tblOrcamento.[PVD-ORC], tblOrcamento.POTENCIAL, 
                         tblCustomer.[Salesperson Code] AS VND, 
                         CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END AS PCUSTO
FROM            tblCustomer INNER JOIN
                         tblOrcamento ON tblCustomer.No_ = tblOrcamento.CODCLI INNER JOIN
                         tblItem ON tblOrcamento.CODPROD = tblItem.No_ INNER JOIN
                         tblDefaultDimension ON tblCustomer.No_ = tblDefaultDimension.No_ AND tblCustomer.Company = tblDefaultDimension.Company LEFT OUTER JOIN
                         tblPrecoCustoOrcamento ON tblOrcamento.CODPROD = tblPrecoCustoOrcamento.CodProd AND tblOrcamento.ANO = tblPrecoCustoOrcamento.Ano
WHERE        (tblDefaultDimension.[Table ID] = 18) AND (tblDefaultDimension.[Dimension Code] = 'UNEGOCIO') AND (tblCustomer.Company = @company) AND 
                         (tblItem.Company = @company) AND (tblCustomer.[Salesperson Code] LIKE @vendedor) AND (tblOrcamento.ANO = @anoorc)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="company" ColumnName="Company" DataSourceName="SAMECAGEST.dbo.tblCustomer" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@company" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="vendedor" ColumnName="Salesperson Code" DataSourceName="SAMECAGEST.dbo.tblCustomer" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@vendedor" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="VND" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="anoorc" ColumnName="ANO" DataSourceName="SAMECAGEST.dbo.tblOrcamento" DataTypeServer="varchar(4)" DbType="AnsiString" Direction="Input" ParameterName="@anoorc" Precision="0" ProviderType="VarChar" Scale="0" Size="4" SourceColumn="ANO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CODCLI" DataSetColumn="CODCLI" />
              <Mapping SourceColumn="DESCCLI" DataSetColumn="DESCCLI" />
              <Mapping SourceColumn="CODPROD" DataSetColumn="CODPROD" />
              <Mapping SourceColumn="DESCITEM" DataSetColumn="DESCITEM" />
              <Mapping SourceColumn="Armazem" DataSetColumn="Armazem" />
              <Mapping SourceColumn="UN" DataSetColumn="UN" />
              <Mapping SourceColumn="QD-1" DataSetColumn="QD-1" />
              <Mapping SourceColumn="VD-1" DataSetColumn="VD-1" />
              <Mapping SourceColumn="CT-1" DataSetColumn="CT-1" />
              <Mapping SourceColumn="PMV-1" DataSetColumn="PMV-1" />
              <Mapping SourceColumn="MRG-1" DataSetColumn="MRG-1" />
              <Mapping SourceColumn="%-1" DataSetColumn="%-1" />
              <Mapping SourceColumn="QD" DataSetColumn="QD" />
              <Mapping SourceColumn="VD" DataSetColumn="VD" />
              <Mapping SourceColumn="CT" DataSetColumn="CT" />
              <Mapping SourceColumn="PMV" DataSetColumn="PMV" />
              <Mapping SourceColumn="MRG" DataSetColumn="MRG" />
              <Mapping SourceColumn="%" DataSetColumn="%" />
              <Mapping SourceColumn="ULTPV" DataSetColumn="ULTPV" />
              <Mapping SourceColumn="ULTPC" DataSetColumn="ULTPC" />
              <Mapping SourceColumn="QD-ORC" DataSetColumn="QD-ORC" />
              <Mapping SourceColumn="PVD-ORC" DataSetColumn="PVD-ORC" />
              <Mapping SourceColumn="POTENCIAL" DataSetColumn="POTENCIAL" />
              <Mapping SourceColumn="VND" DataSetColumn="VND" />
              <Mapping SourceColumn="PCUSTO" DataSetColumn="PCUSTO" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="orcamentoUNTableAdapter" GeneratorDataComponentClassName="orcamentoUNTableAdapter" Name="orcamentoUN" UserDataComponentName="orcamentoUNTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SamecaGestConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblOrcamento.CODCLI, tblCustomer.Name AS DESCCLI, tblOrcamento.CODPROD, tblItem.[Extended Description] AS DESCITEM, tblOrcamento.Armazem, 
                         tblDefaultDimension.[Dimension Value Code] AS UN, tblOrcamento.[QD-1], tblOrcamento.[VD-1], tblOrcamento.[CT-1], tblOrcamento.[PMV-1], 
                         tblOrcamento.[MRG-1], tblOrcamento.[%-1], tblOrcamento.QD, tblOrcamento.VD, tblOrcamento.CT, tblOrcamento.PMV, tblOrcamento.MRG, tblOrcamento.[%], 
                         tblOrcamento.ULTPV, tblOrcamento.ULTPC, tblOrcamento.[QD-ORC], tblOrcamento.[PVD-ORC], tblOrcamento.POTENCIAL, 
                         tblCustomer.[Salesperson Code] AS VND, 
                         CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END AS PCUSTO
FROM            tblCustomer INNER JOIN
                         tblOrcamento ON tblCustomer.No_ = tblOrcamento.CODCLI INNER JOIN
                         tblItem ON tblOrcamento.CODPROD = tblItem.No_ INNER JOIN
                         tblDefaultDimension ON tblCustomer.No_ = tblDefaultDimension.No_ AND tblCustomer.Company = tblDefaultDimension.Company LEFT OUTER JOIN
                         tblPrecoCustoOrcamento ON tblOrcamento.CODPROD = tblPrecoCustoOrcamento.CodProd AND tblOrcamento.ANO = tblPrecoCustoOrcamento.Ano
WHERE        (tblDefaultDimension.[Table ID] = 18) AND (tblDefaultDimension.[Dimension Code] = 'UNEGOCIO') AND (tblCustomer.Company = @company) AND 
                         (tblItem.Company = @company) AND (tblOrcamento.ANO = @anoorc) AND (tblDefaultDimension.[Dimension Value Code] LIKE @un)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="company" ColumnName="Company" DataSourceName="SAMECAGEST.dbo.tblCustomer" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@company" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="anoorc" ColumnName="ANO" DataSourceName="SAMECAGEST.dbo.tblOrcamento" DataTypeServer="varchar(4)" DbType="AnsiString" Direction="Input" ParameterName="@anoorc" Precision="0" ProviderType="VarChar" Scale="0" Size="4" SourceColumn="ANO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="un" ColumnName="Dimension Value Code" DataSourceName="SAMECAGEST.dbo.tblDefaultDimension" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@un" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="UN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CODCLI" DataSetColumn="CODCLI" />
              <Mapping SourceColumn="DESCCLI" DataSetColumn="DESCCLI" />
              <Mapping SourceColumn="CODPROD" DataSetColumn="CODPROD" />
              <Mapping SourceColumn="DESCITEM" DataSetColumn="DESCITEM" />
              <Mapping SourceColumn="Armazem" DataSetColumn="Armazem" />
              <Mapping SourceColumn="UN" DataSetColumn="UN" />
              <Mapping SourceColumn="QD-1" DataSetColumn="QD-1" />
              <Mapping SourceColumn="VD-1" DataSetColumn="VD-1" />
              <Mapping SourceColumn="CT-1" DataSetColumn="CT-1" />
              <Mapping SourceColumn="PMV-1" DataSetColumn="PMV-1" />
              <Mapping SourceColumn="MRG-1" DataSetColumn="MRG-1" />
              <Mapping SourceColumn="%-1" DataSetColumn="%-1" />
              <Mapping SourceColumn="QD" DataSetColumn="QD" />
              <Mapping SourceColumn="VD" DataSetColumn="VD" />
              <Mapping SourceColumn="CT" DataSetColumn="CT" />
              <Mapping SourceColumn="PMV" DataSetColumn="PMV" />
              <Mapping SourceColumn="MRG" DataSetColumn="MRG" />
              <Mapping SourceColumn="%" DataSetColumn="%" />
              <Mapping SourceColumn="ULTPV" DataSetColumn="ULTPV" />
              <Mapping SourceColumn="ULTPC" DataSetColumn="ULTPC" />
              <Mapping SourceColumn="QD-ORC" DataSetColumn="QD-ORC" />
              <Mapping SourceColumn="PVD-ORC" DataSetColumn="PVD-ORC" />
              <Mapping SourceColumn="POTENCIAL" DataSetColumn="POTENCIAL" />
              <Mapping SourceColumn="VND" DataSetColumn="VND" />
              <Mapping SourceColumn="PCUSTO" DataSetColumn="PCUSTO" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblROrcamentoVendedorGeralTableAdapter" GeneratorDataComponentClassName="tblROrcamentoVendedorGeralTableAdapter" Name="tblROrcamentoVendedorGeral" UserDataComponentName="tblROrcamentoVendedorGeralTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SamecaGestConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ORCAMENTO.ANO, SUM(ORCAMENTO.[VD-1]) AS [VD-1], SUM(ORCAMENTO.[MRG-1]) AS [MRG-1], SUM(ORCAMENTO.VD) AS VD, SUM(ORCAMENTO.MRG) 
                         AS MRG, SUM(ORCAMENTO.[VD-ORC]) AS [VD-ORC], SUM(ORCAMENTO.[MRG-ORC]) AS [MRG-ORC], tblCustomer.[Salesperson Code], 
                         tblCustomer.[Salesperson Code] + ' - ' + tblSalesperson.Name AS Name
FROM            tblSalesperson INNER JOIN
                         tblCustomer ON tblSalesperson.Company = tblCustomer.Company AND tblSalesperson.Code = tblCustomer.[Salesperson Code] INNER JOIN
                             (SELECT        tblOrcamento.ANO, tblOrcamento.CODCLI, tblOrcamento.CODPROD, tblOrcamento.Armazem, tblOrcamento.[QD-1], tblOrcamento.[VD-1], 
                                                         tblOrcamento.[CT-1], tblOrcamento.[PMV-1], tblOrcamento.[MRG-1], tblOrcamento.[%-1], tblOrcamento.QD, tblOrcamento.VD, tblOrcamento.CT, 
                                                         tblOrcamento.PMV, tblOrcamento.MRG, tblOrcamento.[%], tblOrcamento.ULTPV, tblOrcamento.ULTPC, tblOrcamento.[QD-ORC], 
                                                         tblOrcamento.[PVD-ORC], tblOrcamento.POTENCIAL, tblOrcamento.Utilizador, tblOrcamento.[QD-ORC] * tblOrcamento.[PVD-ORC] AS [VD-ORC], 
                                                         CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END
                                                          AS PCUSTO, 
                                                         CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END
                                                          * tblOrcamento.[QD-ORC] AS [CT-ORC], 
                                                         tblOrcamento.[QD-ORC] * tblOrcamento.[PVD-ORC] - CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido
                                                          ELSE tblPrecoCustoOrcamento.PCtReal END * tblOrcamento.[QD-ORC] AS [MRG-ORC]
                               FROM            tblOrcamento LEFT OUTER JOIN
                                                         tblPrecoCustoOrcamento ON tblOrcamento.ANO = tblPrecoCustoOrcamento.Ano AND 
                                                         tblOrcamento.CODPROD = tblPrecoCustoOrcamento.CodProd) AS ORCAMENTO ON tblCustomer.No_ = ORCAMENTO.CODCLI
WHERE        (tblCustomer.Company = @company) AND (ORCAMENTO.Armazem LIKE @armazem)
GROUP BY ORCAMENTO.ANO, tblCustomer.[Salesperson Code], tblSalesperson.Name
HAVING        (ORCAMENTO.ANO = @ano)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="company" ColumnName="Company" DataSourceName="SAMECAGEST.dbo.tblCustomer" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@company" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="armazem" ColumnName="Armazem" DataSourceName="SELECT tblOrcamento.ANO, tblOrcamento.CODCLI, tblOrcamento.CODPROD, tblOrcamento.Armazem, tblOrcamento.[QD-1], tblOrcamento.[VD-1], tblOrcamento.[CT-1], tblOrcamento.[PMV-1], tblOrcamento.[MRG-1], tblOrcamento.[%-1], tblOrcamento.QD, tblOrcamento.VD, tblOrcamento.CT, tblOrcamento.PMV, tblOrcamento.MRG, tblOrcamento.[%], tblOrcamento.ULTPV, tblOrcamento.ULTPC, tblOrcamento.[QD-ORC], tblOrcamento.[PVD-ORC], tblOrcamento.POTENCIAL, tblOrcamento.Utilizador, tblOrcamento.[QD-ORC] * tblOrcamento.[PVD-ORC] AS [VD-ORC], CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END AS PCUSTO, CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END * tblOrcamento.[QD-ORC] AS [CT-ORC], tblOrcamento.[QD-ORC] * tblOrcamento.[PVD-ORC] - CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END * tblOrcamento.[QD-ORC] AS [MRG-ORC] FROM tblOrcamento LEFT OUTER JOIN tblPrecoCustoOrcamento ON tblOrcamento.ANO = tblPrecoCustoOrcamento.Ano AND tblOrcamento.CODPROD = tblPrecoCustoOrcamento.CodProd" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@armazem" Precision="0" Scale="0" Size="50" SourceColumn="Armazem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ano" ColumnName="ANO" DataSourceName="SELECT tblOrcamento.ANO, tblOrcamento.CODCLI, tblOrcamento.CODPROD, tblOrcamento.Armazem, tblOrcamento.[QD-1], tblOrcamento.[VD-1], tblOrcamento.[CT-1], tblOrcamento.[PMV-1], tblOrcamento.[MRG-1], tblOrcamento.[%-1], tblOrcamento.QD, tblOrcamento.VD, tblOrcamento.CT, tblOrcamento.PMV, tblOrcamento.MRG, tblOrcamento.[%], tblOrcamento.ULTPV, tblOrcamento.ULTPC, tblOrcamento.[QD-ORC], tblOrcamento.[PVD-ORC], tblOrcamento.POTENCIAL, tblOrcamento.Utilizador, tblOrcamento.[QD-ORC] * tblOrcamento.[PVD-ORC] AS [VD-ORC], CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END AS PCUSTO, CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END * tblOrcamento.[QD-ORC] AS [CT-ORC], tblOrcamento.[QD-ORC] * tblOrcamento.[PVD-ORC] - CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END * tblOrcamento.[QD-ORC] AS [MRG-ORC] FROM tblOrcamento LEFT OUTER JOIN tblPrecoCustoOrcamento ON tblOrcamento.ANO = tblPrecoCustoOrcamento.Ano AND tblOrcamento.CODPROD = tblPrecoCustoOrcamento.CodProd" DataTypeServer="varchar(4)" DbType="AnsiString" Direction="Input" ParameterName="@ano" Precision="0" Scale="0" Size="4" SourceColumn="ANO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ANO" DataSetColumn="ANO" />
              <Mapping SourceColumn="VD-1" DataSetColumn="VD-1" />
              <Mapping SourceColumn="MRG-1" DataSetColumn="MRG-1" />
              <Mapping SourceColumn="VD" DataSetColumn="VD" />
              <Mapping SourceColumn="MRG" DataSetColumn="MRG" />
              <Mapping SourceColumn="VD-ORC" DataSetColumn="VD-ORC" />
              <Mapping SourceColumn="MRG-ORC" DataSetColumn="MRG-ORC" />
              <Mapping SourceColumn="Salesperson Code" DataSetColumn="Salesperson Code" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblROrcamentoUNGeralTableAdapter" GeneratorDataComponentClassName="tblROrcamentoUNGeralTableAdapter" Name="tblROrcamentoUNGeral" UserDataComponentName="tblROrcamentoUNGeralTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SamecaGestConnectionString (MySettings)" DbObjectName="SELECT tblOrcamento.ANO, tblOrcamento.CODCLI, tblOrcamento.CODPROD, tblOrcamento.Armazem, tblOrcamento.[QD-1], tblOrcamento.[VD-1], tblOrcamento.[CT-1], tblOrcamento.[PMV-1], tblOrcamento.[MRG-1], tblOrcamento.[%-1], tblOrcamento.QD, tblOrcamento.VD, tblOrcamento.CT, tblOrcamento.PMV, tblOrcamento.MRG, tblOrcamento.[%], tblOrcamento.ULTPV, tblOrcamento.ULTPC, tblOrcamento.[QD-ORC], tblOrcamento.[PVD-ORC], tblOrcamento.POTENCIAL, tblOrcamento.Utilizador, tblOrcamento.[QD-ORC] * tblOrcamento.[PVD-ORC] AS [VD-ORC], CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END AS PCUSTO, CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END * tblOrcamento.[QD-ORC] AS [CT-ORC], tblOrcamento.[QD-ORC] * tblOrcamento.[PVD-ORC] - CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END * tblOrcamento.[QD-ORC] AS [MRG-ORC] FROM tblOrcamento LEFT OUTER JOIN tblPrecoCustoOrcamento ON tblOrcamento.ANO = tblPrecoCustoOrcamento.Ano AND tblOrcamento.CODPROD = tblPrecoCustoOrcamento.CodProd" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ORCAMENTO.ANO, SUM(ORCAMENTO.[VD-1]) AS [VD-1], SUM(ORCAMENTO.[MRG-1]) AS [MRG-1], SUM(ORCAMENTO.VD) AS VD, SUM(ORCAMENTO.MRG) AS MRG, SUM(ORCAMENTO.[VD-ORC]) AS [VD-ORC], 
                         SUM(ORCAMENTO.[MRG-ORC]) AS [MRG-ORC], tblDimensionValue.Code + ' - ' + tblDimensionValue.Name AS UN
FROM            tblDimensionValue INNER JOIN
                             (SELECT        No_, [Table ID], [Dimension Code], [Dimension Value Code], [Value Posting], [Multi Selection Action], Company
                               FROM            tblDefaultDimension AS tblDefaultDimension_1
                               WHERE        ([Table ID] = 18) AND ([Dimension Code] = 'UNEGOCIO')) AS DEFDIMENSION ON tblDimensionValue.[Dimension Code] = DEFDIMENSION.[Dimension Code] AND 
                         tblDimensionValue.Code = DEFDIMENSION.[Dimension Value Code] AND tblDimensionValue.Company = DEFDIMENSION.Company RIGHT OUTER JOIN
                         tblCustomer ON DEFDIMENSION.No_ = tblCustomer.No_ AND DEFDIMENSION.Company = tblCustomer.Company RIGHT OUTER JOIN
                             (SELECT        tblOrcamento.ANO, tblOrcamento.CODCLI, tblOrcamento.CODPROD, tblOrcamento.Armazem, tblOrcamento.[QD-1], tblOrcamento.[VD-1], tblOrcamento.[CT-1], tblOrcamento.[PMV-1], 
                                                         tblOrcamento.[MRG-1], tblOrcamento.[%-1], tblOrcamento.QD, tblOrcamento.VD, tblOrcamento.CT, tblOrcamento.PMV, tblOrcamento.MRG, tblOrcamento.[%], tblOrcamento.ULTPV, 
                                                         tblOrcamento.ULTPC, tblOrcamento.[QD-ORC], tblOrcamento.[PVD-ORC], tblOrcamento.POTENCIAL, tblOrcamento.Utilizador, tblOrcamento.[QD-ORC] * tblOrcamento.[PVD-ORC] AS [VD-ORC], 
                                                         CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END AS PCUSTO, 
                                                         CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END * tblOrcamento.[QD-ORC] AS [CT-ORC], 
                                                         tblOrcamento.[QD-ORC] * tblOrcamento.[PVD-ORC] - CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END *
                                                          tblOrcamento.[QD-ORC] AS [MRG-ORC]
                               FROM            tblOrcamento LEFT OUTER JOIN
                                                         tblPrecoCustoOrcamento ON tblOrcamento.ANO = tblPrecoCustoOrcamento.Ano AND tblOrcamento.CODPROD = tblPrecoCustoOrcamento.CodProd) AS ORCAMENTO ON 
                         tblCustomer.No_ = ORCAMENTO.CODCLI
WHERE        (tblCustomer.Company = @company) AND (ORCAMENTO.Armazem LIKE @armazem)
GROUP BY ORCAMENTO.ANO, tblDimensionValue.Code, tblDimensionValue.Name
HAVING        (ORCAMENTO.ANO = @ano)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="company" ColumnName="Company" DataSourceName="SAMECAGEST.dbo.tblCustomer" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@company" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="armazem" ColumnName="Armazem" DataSourceName="SELECT tblOrcamento.ANO, tblOrcamento.CODCLI, tblOrcamento.CODPROD, tblOrcamento.Armazem, tblOrcamento.[QD-1], tblOrcamento.[VD-1], tblOrcamento.[CT-1], tblOrcamento.[PMV-1], tblOrcamento.[MRG-1], tblOrcamento.[%-1], tblOrcamento.QD, tblOrcamento.VD, tblOrcamento.CT, tblOrcamento.PMV, tblOrcamento.MRG, tblOrcamento.[%], tblOrcamento.ULTPV, tblOrcamento.ULTPC, tblOrcamento.[QD-ORC], tblOrcamento.[PVD-ORC], tblOrcamento.POTENCIAL, tblOrcamento.Utilizador, tblOrcamento.[QD-ORC] * tblOrcamento.[PVD-ORC] AS [VD-ORC], CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END AS PCUSTO, CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END * tblOrcamento.[QD-ORC] AS [CT-ORC], tblOrcamento.[QD-ORC] * tblOrcamento.[PVD-ORC] - CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END * tblOrcamento.[QD-ORC] AS [MRG-ORC] FROM tblOrcamento LEFT OUTER JOIN tblPrecoCustoOrcamento ON tblOrcamento.ANO = tblPrecoCustoOrcamento.Ano AND tblOrcamento.CODPROD = tblPrecoCustoOrcamento.CodProd" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@armazem" Precision="0" Scale="0" Size="50" SourceColumn="Armazem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ano" ColumnName="ANO" DataSourceName="SELECT tblOrcamento.ANO, tblOrcamento.CODCLI, tblOrcamento.CODPROD, tblOrcamento.Armazem, tblOrcamento.[QD-1], tblOrcamento.[VD-1], tblOrcamento.[CT-1], tblOrcamento.[PMV-1], tblOrcamento.[MRG-1], tblOrcamento.[%-1], tblOrcamento.QD, tblOrcamento.VD, tblOrcamento.CT, tblOrcamento.PMV, tblOrcamento.MRG, tblOrcamento.[%], tblOrcamento.ULTPV, tblOrcamento.ULTPC, tblOrcamento.[QD-ORC], tblOrcamento.[PVD-ORC], tblOrcamento.POTENCIAL, tblOrcamento.Utilizador, tblOrcamento.[QD-ORC] * tblOrcamento.[PVD-ORC] AS [VD-ORC], CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END AS PCUSTO, CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END * tblOrcamento.[QD-ORC] AS [CT-ORC], tblOrcamento.[QD-ORC] * tblOrcamento.[PVD-ORC] - CASE WHEN tblPrecoCustoOrcamento.PCtSugerido &gt; 0 THEN tblPrecoCustoOrcamento.PCtSugerido ELSE tblPrecoCustoOrcamento.PCtReal END * tblOrcamento.[QD-ORC] AS [MRG-ORC] FROM tblOrcamento LEFT OUTER JOIN tblPrecoCustoOrcamento ON tblOrcamento.ANO = tblPrecoCustoOrcamento.Ano AND tblOrcamento.CODPROD = tblPrecoCustoOrcamento.CodProd" DataTypeServer="varchar(4)" DbType="AnsiString" Direction="Input" ParameterName="@ano" Precision="0" Scale="0" Size="4" SourceColumn="ANO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ANO" DataSetColumn="ANO" />
              <Mapping SourceColumn="VD-1" DataSetColumn="VD-1" />
              <Mapping SourceColumn="MRG-1" DataSetColumn="MRG-1" />
              <Mapping SourceColumn="VD" DataSetColumn="VD" />
              <Mapping SourceColumn="MRG" DataSetColumn="MRG" />
              <Mapping SourceColumn="VD-ORC" DataSetColumn="VD-ORC" />
              <Mapping SourceColumn="MRG-ORC" DataSetColumn="MRG-ORC" />
              <Mapping SourceColumn="UN" DataSetColumn="UN" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsManutOrcamento" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsManutOrcamento" msprop:Generator_UserDSName="dsManutOrcamento">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblCustomer" msprop:Generator_TableClassName="tblCustomerDataTable" msprop:Generator_TableVarName="tabletblCustomer" msprop:Generator_RowChangedName="tblCustomerRowChanged" msprop:Generator_TablePropName="tblCustomer" msprop:Generator_RowDeletingName="tblCustomerRowDeleting" msprop:Generator_RowChangingName="tblCustomerRowChanging" msprop:Generator_RowEvHandlerName="tblCustomerRowChangeEventHandler" msprop:Generator_RowDeletedName="tblCustomerRowDeleted" msprop:Generator_RowClassName="tblCustomerRow" msprop:Generator_UserTableName="tblCustomer" msprop:Generator_RowEvArgName="tblCustomerRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="No_" msprop:Generator_ColumnVarNameInTable="columnNo_" msprop:Generator_ColumnPropNameInRow="No_" msprop:Generator_ColumnPropNameInTable="No_Column" msprop:Generator_UserColumnName="No_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblItem" msprop:Generator_TableClassName="tblItemDataTable" msprop:Generator_TableVarName="tabletblItem" msprop:Generator_TablePropName="tblItem" msprop:Generator_RowDeletingName="tblItemRowDeleting" msprop:Generator_RowChangingName="tblItemRowChanging" msprop:Generator_RowEvHandlerName="tblItemRowChangeEventHandler" msprop:Generator_RowDeletedName="tblItemRowDeleted" msprop:Generator_UserTableName="tblItem" msprop:Generator_RowChangedName="tblItemRowChanged" msprop:Generator_RowEvArgName="tblItemRowChangeEvent" msprop:Generator_RowClassName="tblItemRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="No_" msprop:Generator_ColumnVarNameInTable="columnNo_" msprop:Generator_ColumnPropNameInRow="No_" msprop:Generator_ColumnPropNameInTable="No_Column" msprop:Generator_UserColumnName="No_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Extended_x0020_Description" msprop:Generator_ColumnVarNameInTable="columnExtended_Description" msprop:Generator_ColumnPropNameInRow="Extended_Description" msprop:Generator_ColumnPropNameInTable="Extended_DescriptionColumn" msprop:Generator_UserColumnName="Extended Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OrcamentoVendedor" msprop:Generator_TableClassName="OrcamentoVendedorDataTable" msprop:Generator_TableVarName="tableOrcamentoVendedor" msprop:Generator_RowChangedName="OrcamentoVendedorRowChanged" msprop:Generator_TablePropName="OrcamentoVendedor" msprop:Generator_RowDeletingName="OrcamentoVendedorRowDeleting" msprop:Generator_RowChangingName="OrcamentoVendedorRowChanging" msprop:Generator_RowEvHandlerName="OrcamentoVendedorRowChangeEventHandler" msprop:Generator_RowDeletedName="OrcamentoVendedorRowDeleted" msprop:Generator_RowClassName="OrcamentoVendedorRow" msprop:Generator_UserTableName="OrcamentoVendedor" msprop:Generator_RowEvArgName="OrcamentoVendedorRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CODCLI" msprop:Generator_ColumnVarNameInTable="columnCODCLI" msprop:Generator_ColumnPropNameInRow="CODCLI" msprop:Generator_ColumnPropNameInTable="CODCLIColumn" msprop:Generator_UserColumnName="CODCLI">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCCLI" msprop:Generator_ColumnVarNameInTable="columnDESCCLI" msprop:Generator_ColumnPropNameInRow="DESCCLI" msprop:Generator_ColumnPropNameInTable="DESCCLIColumn" msprop:Generator_UserColumnName="DESCCLI" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CODPROD" msprop:Generator_ColumnVarNameInTable="columnCODPROD" msprop:Generator_ColumnPropNameInRow="CODPROD" msprop:Generator_ColumnPropNameInTable="CODPRODColumn" msprop:Generator_UserColumnName="CODPROD">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCITEM" msprop:Generator_ColumnVarNameInTable="columnDESCITEM" msprop:Generator_ColumnPropNameInRow="DESCITEM" msprop:Generator_ColumnPropNameInTable="DESCITEMColumn" msprop:Generator_UserColumnName="DESCITEM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Armazem" msprop:Generator_ColumnVarNameInTable="columnArmazem" msprop:Generator_ColumnPropNameInRow="Armazem" msprop:Generator_ColumnPropNameInTable="ArmazemColumn" msprop:Generator_UserColumnName="Armazem">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UN" msprop:Generator_ColumnVarNameInTable="columnUN" msprop:Generator_ColumnPropNameInRow="UN" msprop:Generator_ColumnPropNameInTable="UNColumn" msprop:Generator_UserColumnName="UN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="QD-1" msprop:Generator_ColumnVarNameInTable="_columnQD_1" msprop:Generator_ColumnPropNameInRow="_QD_1" msprop:Generator_ColumnPropNameInTable="_QD_1Column" msprop:Generator_UserColumnName="QD-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="VD-1" msprop:Generator_ColumnVarNameInTable="_columnVD_1" msprop:Generator_ColumnPropNameInRow="_VD_1" msprop:Generator_ColumnPropNameInTable="_VD_1Column" msprop:Generator_UserColumnName="VD-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="CT-1" msprop:Generator_ColumnVarNameInTable="_columnCT_1" msprop:Generator_ColumnPropNameInRow="_CT_1" msprop:Generator_ColumnPropNameInTable="_CT_1Column" msprop:Generator_UserColumnName="CT-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="PMV-1" msprop:Generator_ColumnVarNameInTable="_columnPMV_1" msprop:Generator_ColumnPropNameInRow="_PMV_1" msprop:Generator_ColumnPropNameInTable="_PMV_1Column" msprop:Generator_UserColumnName="PMV-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="MRG-1" msprop:Generator_ColumnVarNameInTable="_columnMRG_1" msprop:Generator_ColumnPropNameInRow="_MRG_1" msprop:Generator_ColumnPropNameInTable="_MRG_1Column" msprop:Generator_UserColumnName="MRG-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="_x0025_-1" msprop:Generator_ColumnVarNameInTable="_column__1" msprop:Generator_ColumnPropNameInRow="___1" msprop:Generator_ColumnPropNameInTable="___1Column" msprop:Generator_UserColumnName="%-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="QD" msprop:Generator_ColumnVarNameInTable="columnQD" msprop:Generator_ColumnPropNameInRow="QD" msprop:Generator_ColumnPropNameInTable="QDColumn" msprop:Generator_UserColumnName="QD" type="xs:decimal" minOccurs="0" />
              <xs:element name="VD" msprop:Generator_ColumnVarNameInTable="columnVD" msprop:Generator_ColumnPropNameInRow="VD" msprop:Generator_ColumnPropNameInTable="VDColumn" msprop:Generator_UserColumnName="VD" type="xs:decimal" minOccurs="0" />
              <xs:element name="CT" msprop:Generator_ColumnVarNameInTable="columnCT" msprop:Generator_ColumnPropNameInRow="CT" msprop:Generator_ColumnPropNameInTable="CTColumn" msprop:Generator_UserColumnName="CT" type="xs:decimal" minOccurs="0" />
              <xs:element name="PMV" msprop:Generator_ColumnVarNameInTable="columnPMV" msprop:Generator_ColumnPropNameInRow="PMV" msprop:Generator_ColumnPropNameInTable="PMVColumn" msprop:Generator_UserColumnName="PMV" type="xs:decimal" minOccurs="0" />
              <xs:element name="MRG" msprop:Generator_ColumnVarNameInTable="columnMRG" msprop:Generator_ColumnPropNameInRow="MRG" msprop:Generator_ColumnPropNameInTable="MRGColumn" msprop:Generator_UserColumnName="MRG" type="xs:decimal" minOccurs="0" />
              <xs:element name="_x0025_" msprop:Generator_ColumnVarNameInTable="_column_" msprop:Generator_ColumnPropNameInRow="__" msprop:Generator_ColumnPropNameInTable="__Column" msprop:Generator_UserColumnName="%" type="xs:decimal" minOccurs="0" />
              <xs:element name="ULTPV" msprop:Generator_ColumnVarNameInTable="columnULTPV" msprop:Generator_ColumnPropNameInRow="ULTPV" msprop:Generator_ColumnPropNameInTable="ULTPVColumn" msprop:Generator_UserColumnName="ULTPV" type="xs:decimal" minOccurs="0" />
              <xs:element name="ULTPC" msprop:Generator_ColumnVarNameInTable="columnULTPC" msprop:Generator_ColumnPropNameInRow="ULTPC" msprop:Generator_ColumnPropNameInTable="ULTPCColumn" msprop:Generator_UserColumnName="ULTPC" type="xs:decimal" minOccurs="0" />
              <xs:element name="QD-ORC" msprop:Generator_ColumnVarNameInTable="_columnQD_ORC" msprop:Generator_ColumnPropNameInRow="_QD_ORC" msprop:Generator_ColumnPropNameInTable="_QD_ORCColumn" msprop:Generator_UserColumnName="QD-ORC" type="xs:decimal" />
              <xs:element name="PVD-ORC" msprop:Generator_ColumnVarNameInTable="_columnPVD_ORC" msprop:Generator_ColumnPropNameInRow="_PVD_ORC" msprop:Generator_ColumnPropNameInTable="_PVD_ORCColumn" msprop:Generator_UserColumnName="PVD-ORC" type="xs:decimal" minOccurs="0" />
              <xs:element name="POTENCIAL" msprop:Generator_ColumnVarNameInTable="columnPOTENCIAL" msprop:Generator_ColumnPropNameInRow="POTENCIAL" msprop:Generator_ColumnPropNameInTable="POTENCIALColumn" msprop:Generator_UserColumnName="POTENCIAL" type="xs:decimal" minOccurs="0" />
              <xs:element name="VND" msprop:Generator_ColumnVarNameInTable="columnVND" msprop:Generator_ColumnPropNameInRow="VND" msprop:Generator_ColumnPropNameInTable="VNDColumn" msprop:Generator_UserColumnName="VND" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PCUSTO" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPCUSTO" msprop:Generator_ColumnPropNameInRow="PCUSTO" msprop:Generator_ColumnPropNameInTable="PCUSTOColumn" msprop:Generator_UserColumnName="PCUSTO" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="orcamentoUN" msprop:Generator_TableClassName="orcamentoUNDataTable" msprop:Generator_TableVarName="tableorcamentoUN" msprop:Generator_RowChangedName="orcamentoUNRowChanged" msprop:Generator_TablePropName="orcamentoUN" msprop:Generator_RowDeletingName="orcamentoUNRowDeleting" msprop:Generator_RowChangingName="orcamentoUNRowChanging" msprop:Generator_RowEvHandlerName="orcamentoUNRowChangeEventHandler" msprop:Generator_RowDeletedName="orcamentoUNRowDeleted" msprop:Generator_RowClassName="orcamentoUNRow" msprop:Generator_UserTableName="orcamentoUN" msprop:Generator_RowEvArgName="orcamentoUNRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CODCLI" msprop:Generator_ColumnVarNameInTable="columnCODCLI" msprop:Generator_ColumnPropNameInRow="CODCLI" msprop:Generator_ColumnPropNameInTable="CODCLIColumn" msprop:Generator_UserColumnName="CODCLI">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCCLI" msprop:Generator_ColumnVarNameInTable="columnDESCCLI" msprop:Generator_ColumnPropNameInRow="DESCCLI" msprop:Generator_ColumnPropNameInTable="DESCCLIColumn" msprop:Generator_UserColumnName="DESCCLI" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CODPROD" msprop:Generator_ColumnVarNameInTable="columnCODPROD" msprop:Generator_ColumnPropNameInRow="CODPROD" msprop:Generator_ColumnPropNameInTable="CODPRODColumn" msprop:Generator_UserColumnName="CODPROD">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCITEM" msprop:Generator_ColumnVarNameInTable="columnDESCITEM" msprop:Generator_ColumnPropNameInRow="DESCITEM" msprop:Generator_ColumnPropNameInTable="DESCITEMColumn" msprop:Generator_UserColumnName="DESCITEM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Armazem" msprop:Generator_ColumnVarNameInTable="columnArmazem" msprop:Generator_ColumnPropNameInRow="Armazem" msprop:Generator_ColumnPropNameInTable="ArmazemColumn" msprop:Generator_UserColumnName="Armazem">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UN" msprop:Generator_ColumnVarNameInTable="columnUN" msprop:Generator_ColumnPropNameInRow="UN" msprop:Generator_ColumnPropNameInTable="UNColumn" msprop:Generator_UserColumnName="UN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="QD-1" msprop:Generator_ColumnVarNameInTable="_columnQD_1" msprop:Generator_ColumnPropNameInRow="_QD_1" msprop:Generator_ColumnPropNameInTable="_QD_1Column" msprop:Generator_UserColumnName="QD-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="VD-1" msprop:Generator_ColumnVarNameInTable="_columnVD_1" msprop:Generator_ColumnPropNameInRow="_VD_1" msprop:Generator_ColumnPropNameInTable="_VD_1Column" msprop:Generator_UserColumnName="VD-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="CT-1" msprop:Generator_ColumnVarNameInTable="_columnCT_1" msprop:Generator_ColumnPropNameInRow="_CT_1" msprop:Generator_ColumnPropNameInTable="_CT_1Column" msprop:Generator_UserColumnName="CT-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="PMV-1" msprop:Generator_ColumnVarNameInTable="_columnPMV_1" msprop:Generator_ColumnPropNameInRow="_PMV_1" msprop:Generator_ColumnPropNameInTable="_PMV_1Column" msprop:Generator_UserColumnName="PMV-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="MRG-1" msprop:Generator_ColumnVarNameInTable="_columnMRG_1" msprop:Generator_ColumnPropNameInRow="_MRG_1" msprop:Generator_ColumnPropNameInTable="_MRG_1Column" msprop:Generator_UserColumnName="MRG-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="_x0025_-1" msprop:Generator_ColumnVarNameInTable="_column__1" msprop:Generator_ColumnPropNameInRow="___1" msprop:Generator_ColumnPropNameInTable="___1Column" msprop:Generator_UserColumnName="%-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="QD" msprop:Generator_ColumnVarNameInTable="columnQD" msprop:Generator_ColumnPropNameInRow="QD" msprop:Generator_ColumnPropNameInTable="QDColumn" msprop:Generator_UserColumnName="QD" type="xs:decimal" minOccurs="0" />
              <xs:element name="VD" msprop:Generator_ColumnVarNameInTable="columnVD" msprop:Generator_ColumnPropNameInRow="VD" msprop:Generator_ColumnPropNameInTable="VDColumn" msprop:Generator_UserColumnName="VD" type="xs:decimal" minOccurs="0" />
              <xs:element name="CT" msprop:Generator_ColumnVarNameInTable="columnCT" msprop:Generator_ColumnPropNameInRow="CT" msprop:Generator_ColumnPropNameInTable="CTColumn" msprop:Generator_UserColumnName="CT" type="xs:decimal" minOccurs="0" />
              <xs:element name="PMV" msprop:Generator_ColumnVarNameInTable="columnPMV" msprop:Generator_ColumnPropNameInRow="PMV" msprop:Generator_ColumnPropNameInTable="PMVColumn" msprop:Generator_UserColumnName="PMV" type="xs:decimal" minOccurs="0" />
              <xs:element name="MRG" msprop:Generator_ColumnVarNameInTable="columnMRG" msprop:Generator_ColumnPropNameInRow="MRG" msprop:Generator_ColumnPropNameInTable="MRGColumn" msprop:Generator_UserColumnName="MRG" type="xs:decimal" minOccurs="0" />
              <xs:element name="_x0025_" msprop:Generator_ColumnVarNameInTable="_column_" msprop:Generator_ColumnPropNameInRow="__" msprop:Generator_ColumnPropNameInTable="__Column" msprop:Generator_UserColumnName="%" type="xs:decimal" minOccurs="0" />
              <xs:element name="ULTPV" msprop:Generator_ColumnVarNameInTable="columnULTPV" msprop:Generator_ColumnPropNameInRow="ULTPV" msprop:Generator_ColumnPropNameInTable="ULTPVColumn" msprop:Generator_UserColumnName="ULTPV" type="xs:decimal" minOccurs="0" />
              <xs:element name="ULTPC" msprop:Generator_ColumnVarNameInTable="columnULTPC" msprop:Generator_ColumnPropNameInRow="ULTPC" msprop:Generator_ColumnPropNameInTable="ULTPCColumn" msprop:Generator_UserColumnName="ULTPC" type="xs:decimal" minOccurs="0" />
              <xs:element name="QD-ORC" msprop:Generator_ColumnVarNameInTable="_columnQD_ORC" msprop:Generator_ColumnPropNameInRow="_QD_ORC" msprop:Generator_ColumnPropNameInTable="_QD_ORCColumn" msprop:Generator_UserColumnName="QD-ORC" type="xs:decimal" />
              <xs:element name="PVD-ORC" msprop:Generator_ColumnVarNameInTable="_columnPVD_ORC" msprop:Generator_ColumnPropNameInRow="_PVD_ORC" msprop:Generator_ColumnPropNameInTable="_PVD_ORCColumn" msprop:Generator_UserColumnName="PVD-ORC" type="xs:decimal" minOccurs="0" />
              <xs:element name="POTENCIAL" msprop:Generator_ColumnVarNameInTable="columnPOTENCIAL" msprop:Generator_ColumnPropNameInRow="POTENCIAL" msprop:Generator_ColumnPropNameInTable="POTENCIALColumn" msprop:Generator_UserColumnName="POTENCIAL" type="xs:decimal" minOccurs="0" />
              <xs:element name="VND" msprop:Generator_ColumnVarNameInTable="columnVND" msprop:Generator_ColumnPropNameInRow="VND" msprop:Generator_ColumnPropNameInTable="VNDColumn" msprop:Generator_UserColumnName="VND" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PCUSTO" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPCUSTO" msprop:Generator_ColumnPropNameInRow="PCUSTO" msprop:Generator_ColumnPropNameInTable="PCUSTOColumn" msprop:Generator_UserColumnName="PCUSTO" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblROrcamentoVendedorGeral" msprop:Generator_TableClassName="tblROrcamentoVendedorGeralDataTable" msprop:Generator_TableVarName="tabletblROrcamentoVendedorGeral" msprop:Generator_RowChangedName="tblROrcamentoVendedorGeralRowChanged" msprop:Generator_TablePropName="tblROrcamentoVendedorGeral" msprop:Generator_RowDeletingName="tblROrcamentoVendedorGeralRowDeleting" msprop:Generator_RowChangingName="tblROrcamentoVendedorGeralRowChanging" msprop:Generator_RowEvHandlerName="tblROrcamentoVendedorGeralRowChangeEventHandler" msprop:Generator_RowDeletedName="tblROrcamentoVendedorGeralRowDeleted" msprop:Generator_RowClassName="tblROrcamentoVendedorGeralRow" msprop:Generator_UserTableName="tblROrcamentoVendedorGeral" msprop:Generator_RowEvArgName="tblROrcamentoVendedorGeralRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ANO" msprop:Generator_ColumnVarNameInTable="columnANO" msprop:Generator_ColumnPropNameInRow="ANO" msprop:Generator_ColumnPropNameInTable="ANOColumn" msprop:Generator_UserColumnName="ANO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VD-1" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="_columnVD_1" msprop:Generator_ColumnPropNameInRow="_VD_1" msprop:Generator_ColumnPropNameInTable="_VD_1Column" msprop:Generator_UserColumnName="VD-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="MRG-1" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="_columnMRG_1" msprop:Generator_ColumnPropNameInRow="_MRG_1" msprop:Generator_ColumnPropNameInTable="_MRG_1Column" msprop:Generator_UserColumnName="MRG-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="VD" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVD" msprop:Generator_ColumnPropNameInRow="VD" msprop:Generator_ColumnPropNameInTable="VDColumn" msprop:Generator_UserColumnName="VD" type="xs:decimal" minOccurs="0" />
              <xs:element name="MRG" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMRG" msprop:Generator_ColumnPropNameInRow="MRG" msprop:Generator_ColumnPropNameInTable="MRGColumn" msprop:Generator_UserColumnName="MRG" type="xs:decimal" minOccurs="0" />
              <xs:element name="VD-ORC" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="_columnVD_ORC" msprop:Generator_ColumnPropNameInRow="_VD_ORC" msprop:Generator_ColumnPropNameInTable="_VD_ORCColumn" msprop:Generator_UserColumnName="VD-ORC" type="xs:decimal" minOccurs="0" />
              <xs:element name="MRG-ORC" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="_columnMRG_ORC" msprop:Generator_ColumnPropNameInRow="_MRG_ORC" msprop:Generator_ColumnPropNameInTable="_MRG_ORCColumn" msprop:Generator_UserColumnName="MRG-ORC" type="xs:decimal" minOccurs="0" />
              <xs:element name="Salesperson_x0020_Code" msprop:Generator_ColumnVarNameInTable="columnSalesperson_Code" msprop:Generator_ColumnPropNameInRow="Salesperson_Code" msprop:Generator_ColumnPropNameInTable="Salesperson_CodeColumn" msprop:Generator_UserColumnName="Salesperson Code" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblROrcamentoUNGeral" msprop:Generator_TableClassName="tblROrcamentoUNGeralDataTable" msprop:Generator_TableVarName="tabletblROrcamentoUNGeral" msprop:Generator_RowChangedName="tblROrcamentoUNGeralRowChanged" msprop:Generator_TablePropName="tblROrcamentoUNGeral" msprop:Generator_RowDeletingName="tblROrcamentoUNGeralRowDeleting" msprop:Generator_RowChangingName="tblROrcamentoUNGeralRowChanging" msprop:Generator_RowEvHandlerName="tblROrcamentoUNGeralRowChangeEventHandler" msprop:Generator_RowDeletedName="tblROrcamentoUNGeralRowDeleted" msprop:Generator_RowClassName="tblROrcamentoUNGeralRow" msprop:Generator_UserTableName="tblROrcamentoUNGeral" msprop:Generator_RowEvArgName="tblROrcamentoUNGeralRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ANO" msprop:Generator_ColumnVarNameInTable="columnANO" msprop:Generator_ColumnPropNameInRow="ANO" msprop:Generator_ColumnPropNameInTable="ANOColumn" msprop:Generator_UserColumnName="ANO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VD-1" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="_columnVD_1" msprop:Generator_ColumnPropNameInRow="_VD_1" msprop:Generator_ColumnPropNameInTable="_VD_1Column" msprop:Generator_UserColumnName="VD-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="MRG-1" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="_columnMRG_1" msprop:Generator_ColumnPropNameInRow="_MRG_1" msprop:Generator_ColumnPropNameInTable="_MRG_1Column" msprop:Generator_UserColumnName="MRG-1" type="xs:decimal" minOccurs="0" />
              <xs:element name="VD" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVD" msprop:Generator_ColumnPropNameInRow="VD" msprop:Generator_ColumnPropNameInTable="VDColumn" msprop:Generator_UserColumnName="VD" type="xs:decimal" minOccurs="0" />
              <xs:element name="MRG" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMRG" msprop:Generator_ColumnPropNameInRow="MRG" msprop:Generator_ColumnPropNameInTable="MRGColumn" msprop:Generator_UserColumnName="MRG" type="xs:decimal" minOccurs="0" />
              <xs:element name="VD-ORC" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="_columnVD_ORC" msprop:Generator_ColumnPropNameInRow="_VD_ORC" msprop:Generator_ColumnPropNameInTable="_VD_ORCColumn" msprop:Generator_UserColumnName="VD-ORC" type="xs:decimal" minOccurs="0" />
              <xs:element name="MRG-ORC" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="_columnMRG_ORC" msprop:Generator_ColumnPropNameInRow="_MRG_ORC" msprop:Generator_ColumnPropNameInTable="_MRG_ORCColumn" msprop:Generator_UserColumnName="MRG-ORC" type="xs:decimal" minOccurs="0" />
              <xs:element name="UN" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnUN" msprop:Generator_ColumnPropNameInRow="UN" msprop:Generator_ColumnPropNameInTable="UNColumn" msprop:Generator_UserColumnName="UN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="73" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>